Interview Questions

1. Which of the following option is correct?

Options:

a. JOINS can be used to fetch data from multiple tables even if they do not have a common column

b. JOINS cannot be used to fetch data from multiple tables when they do not have a common column

Reveal Answer

2. A condition is referred to as _____:

Options:

a. Join in SQL

b. Join condition

c. Both

d. None of the mentioned

Reveal Answer

3. A_____ is a query that retrieves rows from more than one table or view:

Options:

a. Start

b. End

c. Join

d. All of the mentioned

Reveal Answer

4. Which are the join types in join condition:

Options:

a. Cross join

b. Natural join

c. Join with USING clause

d. All of the mentioned

Reveal Answer

5. Which product is returned in a join query have no join condition

Options:

a. Equijoins

b. Cartesian

c. Both

d. None of the mentioned

Reveal Answer

6. Which is a join condition contains an equality operator:

Options:

a. Equijoins

b. Cartesian

c. Both and b

d. None of the mentioned

Reveal Answer

7. Which join refers to join records from the write table that have no matching key in the left table are include in the result set:

Options:

a. Left outer join

b. Right outer join

c. Full outer join

d. Half outer join

Reveal Answer

8. Which operation are allowed in a join view:

Options:

a. UPDATE

b. INSERT

c. DELETE

d. All of the mentioned

Reveal Answer

9. Which view that contains more than one table in the top-level FROM clause of the SELECT statement:

Options:

a. Join view

b. Datable join view

c. Updatable join view

d. All of the mentioned

Reveal Answer

10. In which case would you use a FULL OUTER JOIN?

Options:

a. Both tables have NULL values.

b. You want all unmatched data from one table.

c. You want all matched data from both tables.

d. You want all unmatched data from both tables.

Reveal Answer

11. Which SQL Join is used for joining the table itself?

Options:

a. Left Join

b. Self-Join

c. Natural join

d. Left Join

Reveal Answer

12. The SQL join which does Cartesian product is called?

Options:

a. Left Join

b. Left Outer Join

c. Right Outer Join

d. Cross Join

Reveal Answer

13. Self-JOIN can be attained by ........ based on requirement but table must join with itself.

Options:

a. INNER-JOIN

b. OUTER-JOIN

c. CROSS-JOIN

d. All of above

Reveal Answer

14. Select the correct query/queries for cross join:

Options:

a. Select * FROM Table1 T1 CROSS JOIN Table1 T2;

b. Select * FROM Table1 T1 ALL CROSS JOIN Table1 T2;

c. Select * FROM Table1 T1,Table1 T2;

d. Select * FROM Table1 T1 CROSS Table1 T2;

Reveal Answer

15. <img src="https://www.bestdotnettraining.com/newimages/campaign/iq1.png" /><br/> Above image depicts:

Options:

a. Outer Join

b. Inner Join

c. Self Join

d. Right Outer Join

Reveal Answer

16. LEFT JOIN and LEFT OUTER JOIN are equivalent.

Options:

a. True

b. False

Reveal Answer

17. <img src="https://www.bestdotnettraining.com/newimages/campaign/iq2.png" /><br/> Choose the query that matches the above image.

Options:

a. Select [List] from [Table A] A inner join [Table B] B on A.value=B.value

b. Select [List] from [Table A] A full outer join [Table B] B on A.value=B.value where A.value is null or B.value is null

c. Select [List] from [Table A] A right join [Table B] B on A.value=B.value where A.value is null

d. Select [List] from [Table A] A full outer join [Table B] B on A.value=B.value

Reveal Answer

Interview Questions and Answer

1. Which of the following option is correct?

2. A condition is referred to as _____:

3. A_____ is a query that retrieves rows from more than one table or view:

4. Which are the join types in join condition:

5. Which product is returned in a join query have no join condition

6. Which is a join condition contains an equality operator:

7. Which join refers to join records from the write table that have no matching key in the left table are include in the result set:

8. Which operation are allowed in a join view:

9. Which view that contains more than one table in the top-level FROM clause of the SELECT statement:

10. In which case would you use a FULL OUTER JOIN?

11. Which SQL Join is used for joining the table itself?

12. The SQL join which does Cartesian product is called?

13. Self-JOIN can be attained by ........ based on requirement but table must join with itself.

14. Select the correct query/queries for cross join:

15. <img src="https://www.bestdotnettraining.com/newimages/campaign/iq1.png" /><br/> Above image depicts:

16. LEFT JOIN and LEFT OUTER JOIN are equivalent.

17. <img src="https://www.bestdotnettraining.com/newimages/campaign/iq2.png" /><br/> Choose the query that matches the above image.

Packages

Trending Certification Courses:

Microsoft Mock Exams:

Other links

About

Resources